Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 1017209 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 179.7 MiB |
| Average record size in memory | 185.2 B |
Variable types
| Numeric | 9 |
|---|---|
| DateTime | 1 |
| Categorical | 9 |
| Unsupported | 1 |
day_of_week is highly overall correlated with open | High correlation |
sales is highly overall correlated with customers and 1 other fields | High correlation |
customers is highly overall correlated with sales | High correlation |
promo2_since_year is highly overall correlated with promo2 | High correlation |
open is highly overall correlated with day_of_week and 1 other fields | High correlation |
store_type is highly overall correlated with assortment | High correlation |
assortment is highly overall correlated with store_type | High correlation |
promo2 is highly overall correlated with promo2_since_year | High correlation |
state_holiday is highly imbalanced (88.2%) | Imbalance |
promo_interval is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
sales has 172871 (17.0%) zeros | Zeros |
customers has 172869 (17.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-09-22 18:41:09.556427 |
|---|---|
| Analysis finished | 2023-09-22 18:42:08.863303 |
| Duration | 59.31 seconds |
| Software version | pandas-profiling v0.0.dev0 |
| Download configuration | config.json |
store
Real number (ℝ)
| Distinct | 1115 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 558.42973 |
| Minimum | 1 |
|---|---|
| Maximum | 1115 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 56 |
| Q1 | 280 |
| median | 558 |
| Q3 | 838 |
| 95-th percentile | 1060 |
| Maximum | 1115 |
| Range | 1114 |
| Interquartile range (IQR) | 558 |
Descriptive statistics
| Standard deviation | 321.90865 |
|---|---|
| Coefficient of variation (CV) | 0.57645329 |
| Kurtosis | -1.2005237 |
| Mean | 558.42973 |
| Median Absolute Deviation (MAD) | 279 |
| Skewness | -0.00095487998 |
| Sum | 5.6803974 × 108 |
| Variance | 103625.18 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 942 | 0.1% |
| 726 | 942 | 0.1% |
| 708 | 942 | 0.1% |
| 709 | 942 | 0.1% |
| 713 | 942 | 0.1% |
| 714 | 942 | 0.1% |
| 715 | 942 | 0.1% |
| 717 | 942 | 0.1% |
| 718 | 942 | 0.1% |
| 720 | 942 | 0.1% |
| Other values (1105) | 1007789 |
| Value | Count | Frequency (%) |
| 1 | 942 | |
| 2 | 942 | |
| 3 | 942 | |
| 4 | 942 | |
| 5 | 942 | |
| 6 | 942 | |
| 7 | 942 | |
| 8 | 942 | |
| 9 | 942 | |
| 10 | 942 |
| Value | Count | Frequency (%) |
| 1115 | 942 | |
| 1114 | 942 | |
| 1113 | 942 | |
| 1112 | 942 | |
| 1111 | 942 | |
| 1110 | 942 | |
| 1109 | 758 | |
| 1108 | 942 | |
| 1107 | 758 | |
| 1106 | 942 |
day_of_week
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9983406 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.997391 |
|---|---|
| Coefficient of variation (CV) | 0.49955499 |
| Kurtosis | -1.2468733 |
| Mean | 3.9983406 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.0015928228 |
| Sum | 4067148 |
| Variance | 3.9895707 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 145845 | |
| 4 | 145845 | |
| 3 | 145665 | |
| 2 | 145664 | |
| 1 | 144730 | |
| 7 | 144730 | |
| 6 | 144730 |
| Value | Count | Frequency (%) |
| 1 | 144730 | |
| 2 | 145664 | |
| 3 | 145665 | |
| 4 | 145845 | |
| 5 | 145845 | |
| 6 | 144730 | |
| 7 | 144730 |
| Value | Count | Frequency (%) |
| 7 | 144730 | |
| 6 | 144730 | |
| 5 | 145845 | |
| 4 | 145845 | |
| 3 | 145665 | |
| 2 | 145664 | |
| 1 | 144730 |
date
Date
| Distinct | 942 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| Minimum | 2013-01-01 00:00:00 |
|---|---|
| Maximum | 2015-07-31 00:00:00 |
sales
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 21734 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5773.819 |
| Minimum | 0 |
|---|---|
| Maximum | 41551 |
| Zeros | 172871 |
| Zeros (%) | 17.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3727 |
| median | 5744 |
| Q3 | 7856 |
| 95-th percentile | 12137 |
| Maximum | 41551 |
| Range | 41551 |
| Interquartile range (IQR) | 4129 |
Descriptive statistics
| Standard deviation | 3849.9262 |
|---|---|
| Coefficient of variation (CV) | 0.66679025 |
| Kurtosis | 1.7783747 |
| Mean | 5773.819 |
| Median Absolute Deviation (MAD) | 2067 |
| Skewness | 0.64145962 |
| Sum | 5.8731806 × 109 |
| Variance | 14821932 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 172871 | 17.0% |
| 5674 | 215 | < 0.1% |
| 5558 | 197 | < 0.1% |
| 5483 | 196 | < 0.1% |
| 6214 | 195 | < 0.1% |
| 6049 | 195 | < 0.1% |
| 5723 | 194 | < 0.1% |
| 5449 | 192 | < 0.1% |
| 5140 | 191 | < 0.1% |
| 5489 | 191 | < 0.1% |
| Other values (21724) | 842572 |
| Value | Count | Frequency (%) |
| 0 | 172871 | |
| 46 | 1 | < 0.1% |
| 124 | 1 | < 0.1% |
| 133 | 1 | < 0.1% |
| 286 | 1 | < 0.1% |
| 297 | 1 | < 0.1% |
| 316 | 1 | < 0.1% |
| 416 | 1 | < 0.1% |
| 506 | 1 | < 0.1% |
| 520 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 41551 | 1 | |
| 38722 | 1 | |
| 38484 | 1 | |
| 38367 | 1 | |
| 38037 | 1 | |
| 38025 | 1 | |
| 37646 | 1 | |
| 37403 | 1 | |
| 37376 | 1 | |
| 37122 | 1 |
customers
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 4086 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 633.14595 |
| Minimum | 0 |
|---|---|
| Maximum | 7388 |
| Zeros | 172869 |
| Zeros (%) | 17.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.5 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 405 |
| median | 609 |
| Q3 | 837 |
| 95-th percentile | 1362 |
| Maximum | 7388 |
| Range | 7388 |
| Interquartile range (IQR) | 432 |
Descriptive statistics
| Standard deviation | 464.41173 |
|---|---|
| Coefficient of variation (CV) | 0.73349871 |
| Kurtosis | 7.0917727 |
| Mean | 633.14595 |
| Median Absolute Deviation (MAD) | 216 |
| Skewness | 1.5986503 |
| Sum | 6.4404176 × 108 |
| Variance | 215678.26 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 172869 | 17.0% |
| 560 | 2414 | 0.2% |
| 576 | 2363 | 0.2% |
| 603 | 2337 | 0.2% |
| 571 | 2330 | 0.2% |
| 555 | 2328 | 0.2% |
| 566 | 2327 | 0.2% |
| 517 | 2326 | 0.2% |
| 539 | 2309 | 0.2% |
| 651 | 2299 | 0.2% |
| Other values (4076) | 823307 |
| Value | Count | Frequency (%) |
| 0 | 172869 | |
| 3 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 18 | 1 | < 0.1% |
| 36 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 44 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7388 | 1 | |
| 5494 | 1 | |
| 5458 | 1 | |
| 5387 | 1 | |
| 5297 | 1 | |
| 5192 | 1 | |
| 5152 | 1 | |
| 5145 | 1 | |
| 5132 | 1 | |
| 5112 | 1 |
open
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1017209 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 844392 | |
| 0 | 172817 | 17.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 844392 | |
| 0 | 172817 | 17.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 844392 | |
| 0 | 172817 | 17.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1017209 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 844392 | |
| 0 | 172817 | 17.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1017209 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 844392 | |
| 0 | 172817 | 17.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1017209 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 844392 | |
| 0 | 172817 | 17.0% |
promo
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1017209 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 629129 | |
| 1 | 388080 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 629129 | |
| 1 | 388080 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 629129 | |
| 1 | 388080 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1017209 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 629129 | |
| 1 | 388080 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1017209 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 629129 | |
| 1 | 388080 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1017209 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 629129 | |
| 1 | 388080 |
state_holiday
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| 0 | |
|---|---|
| a | 20260 |
| b | 6690 |
| c | 4100 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1017209 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 986159 | |
| a | 20260 | 2.0% |
| b | 6690 | 0.7% |
| c | 4100 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 986159 | |
| a | 20260 | 2.0% |
| b | 6690 | 0.7% |
| c | 4100 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 986159 | |
| a | 20260 | 2.0% |
| b | 6690 | 0.7% |
| c | 4100 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 986159 | |
| Lowercase Letter | 31050 | 3.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 20260 | |
| b | 6690 | 21.5% |
| c | 4100 | 13.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 986159 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 986159 | |
| Latin | 31050 | 3.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 20260 | |
| b | 6690 | 21.5% |
| c | 4100 | 13.2% |
Common
| Value | Count | Frequency (%) |
| 0 | 986159 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1017209 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 986159 | |
| a | 20260 | 2.0% |
| b | 6690 | 0.7% |
| c | 4100 | 0.4% |
school_holiday
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1017209 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 835488 | |
| 1 | 181721 | 17.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 835488 | |
| 1 | 181721 | 17.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 835488 | |
| 1 | 181721 | 17.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1017209 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 835488 | |
| 1 | 181721 | 17.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1017209 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 835488 | |
| 1 | 181721 | 17.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1017209 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 835488 | |
| 1 | 181721 | 17.9% |
store_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| a | |
|---|---|
| d | |
| c | |
| b | 15830 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1017209 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | c |
|---|---|
| 2nd row | a |
| 3rd row | a |
| 4th row | c |
| 5th row | a |
Common Values
| Value | Count | Frequency (%) |
| a | 551627 | |
| d | 312912 | |
| c | 136840 | 13.5% |
| b | 15830 | 1.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 551627 | |
| d | 312912 | |
| c | 136840 | 13.5% |
| b | 15830 | 1.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 551627 | |
| d | 312912 | |
| c | 136840 | 13.5% |
| b | 15830 | 1.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1017209 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 551627 | |
| d | 312912 | |
| c | 136840 | 13.5% |
| b | 15830 | 1.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1017209 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 551627 | |
| d | 312912 | |
| c | 136840 | 13.5% |
| b | 15830 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1017209 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 551627 | |
| d | 312912 | |
| c | 136840 | 13.5% |
| b | 15830 | 1.6% |
assortment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| a | |
|---|---|
| c | |
| b | 8294 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1017209 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | a |
|---|---|
| 2nd row | a |
| 3rd row | a |
| 4th row | c |
| 5th row | a |
Common Values
| Value | Count | Frequency (%) |
| a | 537445 | |
| c | 471470 | |
| b | 8294 | 0.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 537445 | |
| c | 471470 | |
| b | 8294 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 537445 | |
| c | 471470 | |
| b | 8294 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1017209 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 537445 | |
| c | 471470 | |
| b | 8294 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1017209 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 537445 | |
| c | 471470 | |
| b | 8294 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1017209 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 537445 | |
| c | 471470 | |
| b | 8294 | 0.8% |
competition_distance
Real number (ℝ)
| Distinct | 655 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5935.4427 |
| Minimum | 20 |
|---|---|
| Maximum | 200000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 15.5 MiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 130 |
| Q1 | 710 |
| median | 2330 |
| Q3 | 6910 |
| 95-th percentile | 20620 |
| Maximum | 200000 |
| Range | 199980 |
| Interquartile range (IQR) | 6200 |
Descriptive statistics
| Standard deviation | 12547.653 |
|---|---|
| Coefficient of variation (CV) | 2.1140214 |
| Kurtosis | 147.78971 |
| Mean | 5935.4427 |
| Median Absolute Deviation (MAD) | 1980 |
| Skewness | 10.242344 |
| Sum | 6.0375857 × 109 |
| Variance | 1.574436 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 250 | 11120 | 1.1% |
| 50 | 7536 | 0.7% |
| 350 | 7536 | 0.7% |
| 1200 | 7374 | 0.7% |
| 190 | 7352 | 0.7% |
| 180 | 6594 | 0.6% |
| 90 | 6594 | 0.6% |
| 330 | 6410 | 0.6% |
| 150 | 6226 | 0.6% |
| 2640 | 5652 | 0.6% |
| Other values (645) | 944815 |
| Value | Count | Frequency (%) |
| 20 | 942 | 0.1% |
| 30 | 3767 | |
| 40 | 4710 | |
| 50 | 7536 | |
| 60 | 2826 | 0.3% |
| 70 | 4526 | |
| 80 | 2826 | 0.3% |
| 90 | 6594 | |
| 100 | 4710 | |
| 110 | 5468 |
| Value | Count | Frequency (%) |
| 200000 | 2642 | |
| 75860 | 942 | 0.1% |
| 58260 | 942 | 0.1% |
| 48330 | 942 | 0.1% |
| 46590 | 942 | 0.1% |
| 45740 | 942 | 0.1% |
| 44320 | 942 | 0.1% |
| 40860 | 942 | 0.1% |
| 40540 | 942 | 0.1% |
| 38710 | 942 | 0.1% |
competition_open_since_month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.7868491 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| median | 7 |
| Q3 | 10 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.3110867 |
|---|---|
| Coefficient of variation (CV) | 0.48786804 |
| Kurtosis | -1.2326075 |
| Mean | 6.7868491 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.04207563 |
| Sum | 6903644 |
| Variance | 10.963295 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 133844 | |
| 4 | 118936 | |
| 11 | 104045 | |
| 3 | 96470 | |
| 7 | 90651 | |
| 12 | 78139 | |
| 6 | 77304 | |
| 10 | 75865 | |
| 5 | 72530 | |
| 2 | 67622 | |
| Other values (2) | 101803 |
| Value | Count | Frequency (%) |
| 1 | 45374 | 4.5% |
| 2 | 67622 | |
| 3 | 96470 | |
| 4 | 118936 | |
| 5 | 72530 | |
| 6 | 77304 | |
| 7 | 90651 | |
| 8 | 56429 | |
| 9 | 133844 | |
| 10 | 75865 |
| Value | Count | Frequency (%) |
| 12 | 78139 | |
| 11 | 104045 | |
| 10 | 75865 | |
| 9 | 133844 | |
| 8 | 56429 | |
| 7 | 90651 | |
| 6 | 77304 | |
| 5 | 72530 | |
| 4 | 118936 | |
| 3 | 96470 |
competition_open_since_year
Real number (ℝ)
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2010.3248 |
| Minimum | 1900 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.6 MiB |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 2002 |
| Q1 | 2008 |
| median | 2012 |
| Q3 | 2014 |
| 95-th percentile | 2015 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 5.5155933 |
|---|---|
| Coefficient of variation (CV) | 0.0027436329 |
| Kurtosis | 124.0713 |
| Mean | 2010.3248 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -7.2356575 |
| Sum | 2.0449205 × 109 |
| Variance | 30.421769 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2013 | 204636 | |
| 2014 | 182822 | |
| 2015 | 110108 | |
| 2012 | 74299 | 7.3% |
| 2005 | 56564 | 5.6% |
| 2010 | 51258 | 5.0% |
| 2009 | 49396 | 4.9% |
| 2011 | 49396 | 4.9% |
| 2008 | 48476 | 4.8% |
| 2007 | 43744 | 4.3% |
| Other values (13) | 146510 |
| Value | Count | Frequency (%) |
| 1900 | 758 | 0.1% |
| 1961 | 942 | 0.1% |
| 1990 | 4710 | 0.5% |
| 1994 | 1884 | 0.2% |
| 1995 | 1700 | 0.2% |
| 1998 | 942 | 0.1% |
| 1999 | 7352 | 0.7% |
| 2000 | 9236 | 0.9% |
| 2001 | 14704 | |
| 2002 | 24882 |
| Value | Count | Frequency (%) |
| 2015 | 110108 | |
| 2014 | 182822 | |
| 2013 | 204636 | |
| 2012 | 74299 | 7.3% |
| 2011 | 49396 | 4.9% |
| 2010 | 51258 | 5.0% |
| 2009 | 49396 | 4.9% |
| 2008 | 48476 | 4.8% |
| 2007 | 43744 | 4.3% |
| 2006 | 42802 | 4.2% |
promo2
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1017209 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 509178 | |
| 0 | 508031 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 509178 | |
| 0 | 508031 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 509178 | |
| 0 | 508031 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1017209 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 509178 | |
| 0 | 508031 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1017209 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 509178 | |
| 0 | 508031 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1017209 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 509178 | |
| 0 | 508031 |
promo2_since_week
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.619033 |
| Minimum | 1 |
|---|---|
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 12 |
| median | 22 |
| Q3 | 37 |
| 95-th percentile | 47 |
| Maximum | 52 |
| Range | 51 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 14.310064 |
|---|---|
| Coefficient of variation (CV) | 0.60587003 |
| Kurtosis | -1.1840463 |
| Mean | 23.619033 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.17872254 |
| Sum | 24025493 |
| Variance | 204.77794 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14 | 84414 | 8.3% |
| 40 | 70046 | 6.9% |
| 10 | 50252 | 4.9% |
| 31 | 50144 | 4.9% |
| 5 | 47242 | 4.6% |
| 1 | 43225 | 4.2% |
| 13 | 41244 | 4.1% |
| 37 | 40234 | 4.0% |
| 22 | 40118 | 3.9% |
| 18 | 38742 | 3.8% |
| Other values (42) | 511548 |
| Value | Count | Frequency (%) |
| 1 | 43225 | |
| 2 | 11424 | 1.1% |
| 3 | 11424 | 1.1% |
| 4 | 11424 | 1.1% |
| 5 | 47242 | |
| 6 | 12366 | 1.2% |
| 7 | 11424 | 1.1% |
| 8 | 11424 | 1.1% |
| 9 | 23876 | |
| 10 | 50252 |
| Value | Count | Frequency (%) |
| 52 | 7448 | 0.7% |
| 51 | 7448 | 0.7% |
| 50 | 8390 | 0.8% |
| 49 | 8206 | 0.8% |
| 48 | 15742 | |
| 47 | 7448 | 0.7% |
| 46 | 7448 | 0.7% |
| 45 | 36716 | |
| 44 | 10090 | 1.0% |
| 43 | 7448 | 0.7% |
promo2_since_year
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2012.7933 |
| Minimum | 2009 |
|---|---|
| Maximum | 2015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.6 MiB |
Quantile statistics
| Minimum | 2009 |
|---|---|
| 5-th percentile | 2009 |
| Q1 | 2012 |
| median | 2013 |
| Q3 | 2014 |
| 95-th percentile | 2015 |
| Maximum | 2015 |
| Range | 6 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.6626582 |
|---|---|
| Coefficient of variation (CV) | 0.00082604518 |
| Kurtosis | -0.21007513 |
| Mean | 2012.7933 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.78443626 |
| Sum | 2.0474315 × 109 |
| Variance | 2.7644323 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2013 | 309023 | |
| 2014 | 274066 | |
| 2015 | 124380 | |
| 2011 | 115056 | 11.3% |
| 2012 | 73174 | 7.2% |
| 2009 | 65270 | 6.4% |
| 2010 | 56240 | 5.5% |
| Value | Count | Frequency (%) |
| 2009 | 65270 | 6.4% |
| 2010 | 56240 | 5.5% |
| 2011 | 115056 | 11.3% |
| 2012 | 73174 | 7.2% |
| 2013 | 309023 | |
| 2014 | 274066 | |
| 2015 | 124380 |
| Value | Count | Frequency (%) |
| 2015 | 124380 | |
| 2014 | 274066 | |
| 2013 | 309023 | |
| 2012 | 73174 | 7.2% |
| 2011 | 115056 | 11.3% |
| 2010 | 56240 | 5.5% |
| 2009 | 65270 | 6.4% |
promo_interval
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
month_map
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| May | |
|---|---|
| Mar | |
| Jan | |
| Jun | |
| Apr | |
| Other values (7) |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0604596 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3113127 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Jul |
|---|---|
| 2nd row | Jul |
| 3rd row | Jul |
| 4th row | Jul |
| 5th row | Jul |
Common Values
| Value | Count | Frequency (%) |
| May | 103695 | |
| Mar | 103695 | |
| Jan | 103694 | |
| Jun | 100350 | |
| Apr | 100350 | |
| Jul | 98115 | |
| Fev | 93660 | |
| Dec | 63550 | |
| Oct | 63550 | |
| Aug | 63550 | |
| Other values (2) | 123000 |
Length
| Value | Count | Frequency (%) |
| may | 103695 | |
| mar | 103695 | |
| jan | 103694 | |
| jun | 100350 | |
| apr | 100350 | |
| jul | 98115 | |
| fev | 93660 | |
| dec | 63550 | |
| oct | 63550 | |
| aug | 63550 | |
| Other values (2) | 123000 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 311084 | 10.0% |
| J | 302159 | 9.7% |
| u | 262015 | 8.4% |
| e | 218710 | 7.0% |
| M | 207390 | 6.7% |
| r | 204045 | 6.6% |
| n | 204044 | 6.6% |
| A | 163900 | 5.3% |
| p | 161850 | 5.2% |
| v | 155160 | 5.0% |
| Other values (11) | 922770 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2095918 | |
| Uppercase Letter | 1017209 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 311084 | |
| u | 262015 | |
| e | 218710 | |
| r | 204045 | |
| n | 204044 | |
| p | 161850 | |
| v | 155160 | |
| c | 127100 | |
| t | 125050 | |
| y | 103695 | 4.9% |
| Other values (3) | 223165 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 302159 | |
| M | 207390 | |
| A | 163900 | |
| F | 93660 | 9.2% |
| O | 63550 | 6.2% |
| D | 63550 | 6.2% |
| N | 61500 | 6.0% |
| S | 61500 | 6.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3113127 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 311084 | 10.0% |
| J | 302159 | 9.7% |
| u | 262015 | 8.4% |
| e | 218710 | 7.0% |
| M | 207390 | 6.7% |
| r | 204045 | 6.6% |
| n | 204044 | 6.6% |
| A | 163900 | 5.3% |
| p | 161850 | 5.2% |
| v | 155160 | 5.0% |
| Other values (11) | 922770 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3113127 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 311084 | 10.0% |
| J | 302159 | 9.7% |
| u | 262015 | 8.4% |
| e | 218710 | 7.0% |
| M | 207390 | 6.7% |
| r | 204045 | 6.6% |
| n | 204044 | 6.6% |
| A | 163900 | 5.3% |
| p | 161850 | 5.2% |
| v | 155160 | 5.0% |
| Other values (11) | 922770 |
is_promo
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 15.5 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1017209 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 853337 | |
| 1 | 163872 | 16.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 853337 | |
| 1 | 163872 | 16.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 853337 | |
| 1 | 163872 | 16.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1017209 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 853337 | |
| 1 | 163872 | 16.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1017209 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 853337 | |
| 1 | 163872 | 16.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1017209 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 853337 | |
| 1 | 163872 | 16.1% |
| store | day_of_week | sales | customers | competition_distance | competition_open_since_month | competition_open_since_year | promo2_since_week | promo2_since_year | open | promo | state_holiday | school_holiday | store_type | assortment | promo2 | month_map | is_promo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| store | 1.000 | -0.000 | 0.001 | 0.022 | -0.045 | -0.033 | 0.002 | 0.004 | 0.008 | 0.006 | 0.000 | 0.000 | 0.000 | 0.095 | 0.111 | 0.072 | 0.000 | 0.036 |
| day_of_week | -0.000 | 1.000 | -0.451 | -0.431 | -0.000 | -0.002 | 0.000 | -0.002 | 0.001 | 0.876 | 0.495 | 0.120 | 0.264 | 0.000 | 0.000 | 0.000 | 0.031 | 0.011 |
| sales | 0.001 | -0.451 | 1.000 | 0.903 | -0.026 | -0.002 | 0.029 | 0.056 | 0.063 | 0.705 | 0.453 | 0.155 | 0.083 | 0.108 | 0.081 | 0.104 | 0.044 | 0.051 |
| customers | 0.022 | -0.431 | 0.903 | 1.000 | -0.178 | 0.002 | 0.015 | 0.032 | 0.122 | 0.327 | 0.279 | 0.071 | 0.048 | 0.318 | 0.271 | 0.182 | 0.024 | 0.082 |
| competition_distance | -0.045 | -0.000 | -0.026 | -0.178 | 1.000 | -0.024 | 0.007 | -0.014 | 0.029 | 0.013 | 0.000 | 0.000 | 0.002 | 0.045 | 0.063 | 0.159 | 0.000 | 0.070 |
| competition_open_since_month | -0.033 | -0.002 | -0.002 | 0.002 | -0.024 | 1.000 | -0.234 | 0.108 | 0.017 | 0.025 | 0.013 | 0.061 | 0.132 | 0.068 | 0.059 | 0.130 | 0.326 | 0.085 |
| competition_open_since_year | 0.002 | 0.000 | 0.029 | 0.015 | 0.007 | -0.234 | 1.000 | 0.017 | 0.031 | 0.000 | 0.000 | 0.001 | 0.002 | 0.054 | 0.078 | 0.054 | 0.002 | 0.029 |
| promo2_since_week | 0.004 | -0.002 | 0.056 | 0.032 | -0.014 | 0.108 | 0.017 | 1.000 | -0.121 | 0.033 | 0.052 | 0.101 | 0.182 | 0.073 | 0.091 | 0.283 | 0.432 | 0.161 |
| promo2_since_year | 0.008 | 0.001 | 0.063 | 0.122 | 0.029 | 0.017 | 0.031 | -0.121 | 1.000 | 0.007 | 0.015 | 0.016 | 0.027 | 0.085 | 0.110 | 0.682 | 0.099 | 0.306 |
| open | 0.006 | 0.876 | 0.705 | 0.327 | 0.013 | 0.025 | 0.000 | 0.033 | 0.007 | 1.000 | 0.295 | 0.378 | 0.086 | 0.051 | 0.039 | 0.008 | 0.074 | 0.000 |
| promo | 0.000 | 0.495 | 0.453 | 0.279 | 0.000 | 0.013 | 0.000 | 0.052 | 0.015 | 0.295 | 1.000 | 0.054 | 0.067 | 0.000 | 0.000 | 0.000 | 0.052 | 0.005 |
| state_holiday | 0.000 | 0.120 | 0.155 | 0.071 | 0.000 | 0.061 | 0.001 | 0.101 | 0.016 | 0.378 | 0.054 | 1.000 | 0.213 | 0.002 | 0.002 | 0.011 | 0.220 | 0.027 |
| school_holiday | 0.000 | 0.264 | 0.083 | 0.048 | 0.002 | 0.132 | 0.002 | 0.182 | 0.027 | 0.086 | 0.067 | 0.213 | 1.000 | 0.002 | 0.002 | 0.007 | 0.385 | 0.027 |
| store_type | 0.095 | 0.000 | 0.108 | 0.318 | 0.045 | 0.068 | 0.054 | 0.073 | 0.085 | 0.051 | 0.000 | 0.002 | 0.002 | 1.000 | 0.537 | 0.106 | 0.007 | 0.045 |
| assortment | 0.111 | 0.000 | 0.081 | 0.271 | 0.063 | 0.059 | 0.078 | 0.091 | 0.110 | 0.039 | 0.000 | 0.002 | 0.002 | 0.537 | 1.000 | 0.015 | 0.005 | 0.008 |
| promo2 | 0.072 | 0.000 | 0.104 | 0.182 | 0.159 | 0.130 | 0.054 | 0.283 | 0.682 | 0.008 | 0.000 | 0.011 | 0.007 | 0.106 | 0.015 | 1.000 | 0.028 | 0.438 |
| month_map | 0.000 | 0.031 | 0.044 | 0.024 | 0.000 | 0.326 | 0.002 | 0.432 | 0.099 | 0.074 | 0.052 | 0.220 | 0.385 | 0.007 | 0.005 | 0.028 | 1.000 | 0.274 |
| is_promo | 0.036 | 0.011 | 0.051 | 0.082 | 0.070 | 0.085 | 0.029 | 0.161 | 0.306 | 0.000 | 0.005 | 0.027 | 0.027 | 0.045 | 0.008 | 0.438 | 0.274 | 1.000 |
| store | day_of_week | date | sales | customers | open | promo | state_holiday | school_holiday | store_type | assortment | competition_distance | competition_open_since_month | competition_open_since_year | promo2 | promo2_since_week | promo2_since_year | promo_interval | month_map | is_promo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 5 | 2015-07-31 | 5263 | 555 | 1 | 1 | 0 | 1 | c | a | 1270.000 | 9 | 2008 | 0 | 31 | 2015 | 0 | Jul | 0 |
| 1 | 2 | 5 | 2015-07-31 | 6064 | 625 | 1 | 1 | 0 | 1 | a | a | 570.000 | 11 | 2007 | 1 | 13 | 2010 | Jan,Apr,Jul,Oct | Jul | 1 |
| 2 | 3 | 5 | 2015-07-31 | 8314 | 821 | 1 | 1 | 0 | 1 | a | a | 14130.000 | 12 | 2006 | 1 | 14 | 2011 | Jan,Apr,Jul,Oct | Jul | 1 |
| 3 | 4 | 5 | 2015-07-31 | 13995 | 1498 | 1 | 1 | 0 | 1 | c | c | 620.000 | 9 | 2009 | 0 | 31 | 2015 | 0 | Jul | 0 |
| 4 | 5 | 5 | 2015-07-31 | 4822 | 559 | 1 | 1 | 0 | 1 | a | a | 29910.000 | 4 | 2015 | 0 | 31 | 2015 | 0 | Jul | 0 |
| 5 | 6 | 5 | 2015-07-31 | 5651 | 589 | 1 | 1 | 0 | 1 | a | a | 310.000 | 12 | 2013 | 0 | 31 | 2015 | 0 | Jul | 0 |
| 6 | 7 | 5 | 2015-07-31 | 15344 | 1414 | 1 | 1 | 0 | 1 | a | c | 24000.000 | 4 | 2013 | 0 | 31 | 2015 | 0 | Jul | 0 |
| 7 | 8 | 5 | 2015-07-31 | 8492 | 833 | 1 | 1 | 0 | 1 | a | a | 7520.000 | 10 | 2014 | 0 | 31 | 2015 | 0 | Jul | 0 |
| 8 | 9 | 5 | 2015-07-31 | 8565 | 687 | 1 | 1 | 0 | 1 | a | c | 2030.000 | 8 | 2000 | 0 | 31 | 2015 | 0 | Jul | 0 |
| 9 | 10 | 5 | 2015-07-31 | 7185 | 681 | 1 | 1 | 0 | 1 | a | a | 3160.000 | 9 | 2009 | 0 | 31 | 2015 | 0 | Jul | 0 |
| store | day_of_week | date | sales | customers | open | promo | state_holiday | school_holiday | store_type | assortment | competition_distance | competition_open_since_month | competition_open_since_year | promo2 | promo2_since_week | promo2_since_year | promo_interval | month_map | is_promo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1017199 | 1106 | 2 | 2013-01-01 | 0 | 0 | 0 | 0 | a | 1 | a | c | 5330.000 | 9 | 2011 | 1 | 31 | 2013 | Jan,Apr,Jul,Oct | Jan | 1 |
| 1017200 | 1107 | 2 | 2013-01-01 | 0 | 0 | 0 | 0 | a | 1 | a | a | 1400.000 | 6 | 2012 | 1 | 13 | 2010 | Jan,Apr,Jul,Oct | Jan | 1 |
| 1017201 | 1108 | 2 | 2013-01-01 | 0 | 0 | 0 | 0 | a | 1 | a | a | 540.000 | 4 | 2004 | 0 | 1 | 2013 | 0 | Jan | 0 |
| 1017202 | 1109 | 2 | 2013-01-01 | 0 | 0 | 0 | 0 | a | 1 | c | a | 3490.000 | 4 | 2011 | 1 | 22 | 2012 | Jan,Apr,Jul,Oct | Jan | 1 |
| 1017203 | 1110 | 2 | 2013-01-01 | 0 | 0 | 0 | 0 | a | 1 | c | c | 900.000 | 9 | 2010 | 0 | 1 | 2013 | 0 | Jan | 0 |
| 1017204 | 1111 | 2 | 2013-01-01 | 0 | 0 | 0 | 0 | a | 1 | a | a | 1900.000 | 6 | 2014 | 1 | 31 | 2013 | Jan,Apr,Jul,Oct | Jan | 1 |
| 1017205 | 1112 | 2 | 2013-01-01 | 0 | 0 | 0 | 0 | a | 1 | c | c | 1880.000 | 4 | 2006 | 0 | 1 | 2013 | 0 | Jan | 0 |
| 1017206 | 1113 | 2 | 2013-01-01 | 0 | 0 | 0 | 0 | a | 1 | a | c | 9260.000 | 1 | 2013 | 0 | 1 | 2013 | 0 | Jan | 0 |
| 1017207 | 1114 | 2 | 2013-01-01 | 0 | 0 | 0 | 0 | a | 1 | a | c | 870.000 | 1 | 2013 | 0 | 1 | 2013 | 0 | Jan | 0 |
| 1017208 | 1115 | 2 | 2013-01-01 | 0 | 0 | 0 | 0 | a | 1 | d | c | 5350.000 | 1 | 2013 | 1 | 22 | 2012 | Mar,Jun,Sept,Dec | Jan | 0 |